update
	docmaloc
set
	idschetsubshetdtm = (select idschetsubshetdtm from docmaloc d where viddocm = 2 and d.numdocm = docmaloc.numdocm and d.datedocm = docmaloc.datedocm and d.kodsklm = docmaloc.kodsklmkor and docmaloc.kodsklm = d.kodsklmkor), idschetsubshetktm = (select idschetsubshetktm from docmaloc d where viddocm = 2 and d.numdocm = docmaloc.numdocm and d.datedocm = docmaloc.datedocm and d.kodsklm = docmaloc.kodsklmkor and docmaloc.kodsklm = d.kodsklmkor)
where
	(idschetsubshetdtm is null or idschetsubshetktm is null) and viddocm = 1 and idsklm = 1

__________

SELECT
	tbSprAPrizSchet.id1, tbSprAPrizSchet.tabn, spr_works.fio 
FROM
	maindatabase..tbSprAPrizSchet 
inner join 
	spr_works on tbSprAPrizSchet.tabn = spr_works.tabn
WHERE 
	tbSprAPrizSchet.idSchetSubSchet = 290
order by
	fio

__________

use
	malocenka
select
	numdocm, count(*)
from
	docmaloc
where
	idgroperm in(select idgroper from tbgroper where priznok='Расход' and groper=8) 
group by
	idgroperm, numdocm
HAVING
	COUNT(*) != 2